
let sqlStrTotal = []

let create_tbl_sql = [
    ["create table if not exists test_tbl2(id int, name varchar, age int);"],
    ["insert into test_tbl2 values($1, $2, $3)",                [1, 'zhanghua', 22]],
    ["select count(*) from test_tbl2"],
    ["select name,age from test_tbl order by $1 desc",          ['age']],
    ["update test_tbl set age=$1 where name='$2'",              [50, 'zhou']],
    ["select name,age from test_tbl where age > $1",            [50]],
    ["drop table test_tbl"]
]


sqlStrTotal = Array.prototype.concat(create_tbl_sql)

module.exports = sqlStrTotal;